{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "import numpy as np\n",
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "ts_indicator = \"C:\\\\quanttime\\\\data\\\\finance\\\\ts\\\\indicator\\\\\" \n",
    "ts_stock_name = \"C:\\\\quanttime\\\\data\\\\basic_info\\\\all_stock_info_ts.csv\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# ts_code与stock name的关系\n",
    "df_stock_name = pd.read_csv(ts_stock_name,index_col=[\"ts_code\"],usecols=[\"ts_code\",\"name\"],encoding=\"gbk\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 指标的英文缩写与中文的对应关系\n",
    "indicator_name = pd.read_csv(ts_indicator+'field_name.txt',encoding='gbk')\n",
    "indicator_name['field_name_en'] = indicator_name['ts_code:ts代码'].apply(lambda x: str(x).split(':')[0])\n",
    "indicator_name['field_name_en_cn'] = indicator_name['ts_code:ts代码'].apply(lambda x: str(x).split(':')[1])\n",
    "indicator_name = indicator_name.set_index(\"field_name_en\")\n",
    "indicator_name = indicator_name[[\"field_name_en_cn\"]]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_indicator_file = os.listdir(ts_indicator)\n",
    "# 只挑选出股票csv指标文件\n",
    "all_csv_file = [d for d in all_indicator_file if len(d)==13 and 'csv' in d ]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ts_code</th>\n",
       "      <th>roe_5</th>\n",
       "      <th>roe_3</th>\n",
       "      <th>roe_5_std</th>\n",
       "      <th>roe_3_std</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000001.SZ</td>\n",
       "      <td>13.07</td>\n",
       "      <td>11.37</td>\n",
       "      <td>2.21</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>000002.SZ</td>\n",
       "      <td>20.84</td>\n",
       "      <td>21.96</td>\n",
       "      <td>1.87</td>\n",
       "      <td>1.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>000004.SZ</td>\n",
       "      <td>7.02</td>\n",
       "      <td>9.57</td>\n",
       "      <td>18.02</td>\n",
       "      <td>22.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>000005.SZ</td>\n",
       "      <td>4.26</td>\n",
       "      <td>6.90</td>\n",
       "      <td>6.07</td>\n",
       "      <td>4.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>000006.SZ</td>\n",
       "      <td>13.76</td>\n",
       "      <td>15.56</td>\n",
       "      <td>2.42</td>\n",
       "      <td>0.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>000007.SZ</td>\n",
       "      <td>-9.45</td>\n",
       "      <td>-14.17</td>\n",
       "      <td>30.73</td>\n",
       "      <td>38.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>000008.SZ</td>\n",
       "      <td>8.27</td>\n",
       "      <td>9.77</td>\n",
       "      <td>4.54</td>\n",
       "      <td>3.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>000009.SZ</td>\n",
       "      <td>8.21</td>\n",
       "      <td>4.07</td>\n",
       "      <td>6.04</td>\n",
       "      <td>0.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>000010.SZ</td>\n",
       "      <td>-32.89</td>\n",
       "      <td>-51.38</td>\n",
       "      <td>38.40</td>\n",
       "      <td>39.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>000011.SZ</td>\n",
       "      <td>17.42</td>\n",
       "      <td>19.35</td>\n",
       "      <td>5.58</td>\n",
       "      <td>3.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>000012.SZ</td>\n",
       "      <td>8.77</td>\n",
       "      <td>8.49</td>\n",
       "      <td>2.08</td>\n",
       "      <td>2.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>000014.SZ</td>\n",
       "      <td>8.03</td>\n",
       "      <td>7.65</td>\n",
       "      <td>5.77</td>\n",
       "      <td>7.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>000016.SZ</td>\n",
       "      <td>13.25</td>\n",
       "      <td>33.76</td>\n",
       "      <td>42.66</td>\n",
       "      <td>41.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>000017.SZ</td>\n",
       "      <td>14.00</td>\n",
       "      <td>6.50</td>\n",
       "      <td>21.46</td>\n",
       "      <td>12.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>000018.SZ</td>\n",
       "      <td>-8.03</td>\n",
       "      <td>-30.85</td>\n",
       "      <td>69.04</td>\n",
       "      <td>79.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>000019.SZ</td>\n",
       "      <td>2.82</td>\n",
       "      <td>5.47</td>\n",
       "      <td>7.03</td>\n",
       "      <td>7.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>000020.SZ</td>\n",
       "      <td>0.71</td>\n",
       "      <td>1.02</td>\n",
       "      <td>1.70</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>000021.SZ</td>\n",
       "      <td>5.94</td>\n",
       "      <td>7.52</td>\n",
       "      <td>2.72</td>\n",
       "      <td>2.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>000023.SZ</td>\n",
       "      <td>5.69</td>\n",
       "      <td>5.48</td>\n",
       "      <td>1.82</td>\n",
       "      <td>2.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>000025.SZ</td>\n",
       "      <td>6.48</td>\n",
       "      <td>6.30</td>\n",
       "      <td>2.02</td>\n",
       "      <td>2.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>000026.SZ</td>\n",
       "      <td>6.64</td>\n",
       "      <td>5.94</td>\n",
       "      <td>1.51</td>\n",
       "      <td>1.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>000027.SZ</td>\n",
       "      <td>6.76</td>\n",
       "      <td>4.25</td>\n",
       "      <td>3.38</td>\n",
       "      <td>1.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>000028.SZ</td>\n",
       "      <td>14.79</td>\n",
       "      <td>13.48</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>000029.SZ</td>\n",
       "      <td>12.77</td>\n",
       "      <td>11.88</td>\n",
       "      <td>3.27</td>\n",
       "      <td>3.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>000030.SZ</td>\n",
       "      <td>14.03</td>\n",
       "      <td>14.50</td>\n",
       "      <td>1.54</td>\n",
       "      <td>0.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>000031.SZ</td>\n",
       "      <td>13.79</td>\n",
       "      <td>15.47</td>\n",
       "      <td>3.07</td>\n",
       "      <td>2.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>000032.SZ</td>\n",
       "      <td>4.19</td>\n",
       "      <td>4.56</td>\n",
       "      <td>2.01</td>\n",
       "      <td>2.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>000034.SZ</td>\n",
       "      <td>24.84</td>\n",
       "      <td>22.28</td>\n",
       "      <td>11.87</td>\n",
       "      <td>5.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>000035.SZ</td>\n",
       "      <td>12.21</td>\n",
       "      <td>8.83</td>\n",
       "      <td>5.05</td>\n",
       "      <td>1.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>000036.SZ</td>\n",
       "      <td>22.13</td>\n",
       "      <td>35.09</td>\n",
       "      <td>18.30</td>\n",
       "      <td>11.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3580</th>\n",
       "      <td>603939.SH</td>\n",
       "      <td>15.08</td>\n",
       "      <td>10.66</td>\n",
       "      <td>6.02</td>\n",
       "      <td>0.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3581</th>\n",
       "      <td>603955.SH</td>\n",
       "      <td>9.78</td>\n",
       "      <td>9.18</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3582</th>\n",
       "      <td>603956.SH</td>\n",
       "      <td>24.69</td>\n",
       "      <td>17.91</td>\n",
       "      <td>8.75</td>\n",
       "      <td>3.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3583</th>\n",
       "      <td>603958.SH</td>\n",
       "      <td>9.06</td>\n",
       "      <td>1.55</td>\n",
       "      <td>10.31</td>\n",
       "      <td>6.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3584</th>\n",
       "      <td>603959.SH</td>\n",
       "      <td>15.98</td>\n",
       "      <td>14.10</td>\n",
       "      <td>2.75</td>\n",
       "      <td>1.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3585</th>\n",
       "      <td>603960.SH</td>\n",
       "      <td>16.01</td>\n",
       "      <td>15.08</td>\n",
       "      <td>1.46</td>\n",
       "      <td>1.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3586</th>\n",
       "      <td>603963.SH</td>\n",
       "      <td>21.03</td>\n",
       "      <td>14.30</td>\n",
       "      <td>12.24</td>\n",
       "      <td>10.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3587</th>\n",
       "      <td>603966.SH</td>\n",
       "      <td>11.14</td>\n",
       "      <td>9.60</td>\n",
       "      <td>2.41</td>\n",
       "      <td>1.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3588</th>\n",
       "      <td>603967.SH</td>\n",
       "      <td>26.35</td>\n",
       "      <td>26.60</td>\n",
       "      <td>4.29</td>\n",
       "      <td>2.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3589</th>\n",
       "      <td>603968.SH</td>\n",
       "      <td>14.49</td>\n",
       "      <td>13.14</td>\n",
       "      <td>2.90</td>\n",
       "      <td>0.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3590</th>\n",
       "      <td>603969.SH</td>\n",
       "      <td>11.08</td>\n",
       "      <td>8.55</td>\n",
       "      <td>3.92</td>\n",
       "      <td>0.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3591</th>\n",
       "      <td>603970.SH</td>\n",
       "      <td>24.30</td>\n",
       "      <td>18.41</td>\n",
       "      <td>8.16</td>\n",
       "      <td>4.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3592</th>\n",
       "      <td>603976.SH</td>\n",
       "      <td>12.81</td>\n",
       "      <td>11.39</td>\n",
       "      <td>2.72</td>\n",
       "      <td>2.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3593</th>\n",
       "      <td>603977.SH</td>\n",
       "      <td>12.83</td>\n",
       "      <td>8.36</td>\n",
       "      <td>6.19</td>\n",
       "      <td>3.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3594</th>\n",
       "      <td>603978.SH</td>\n",
       "      <td>16.64</td>\n",
       "      <td>13.99</td>\n",
       "      <td>6.08</td>\n",
       "      <td>5.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3595</th>\n",
       "      <td>603979.SH</td>\n",
       "      <td>8.45</td>\n",
       "      <td>5.87</td>\n",
       "      <td>4.39</td>\n",
       "      <td>1.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3596</th>\n",
       "      <td>603980.SH</td>\n",
       "      <td>34.62</td>\n",
       "      <td>16.19</td>\n",
       "      <td>26.37</td>\n",
       "      <td>2.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3597</th>\n",
       "      <td>603982.SH</td>\n",
       "      <td>11.93</td>\n",
       "      <td>11.57</td>\n",
       "      <td>1.46</td>\n",
       "      <td>1.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3598</th>\n",
       "      <td>603985.SH</td>\n",
       "      <td>15.77</td>\n",
       "      <td>16.06</td>\n",
       "      <td>4.50</td>\n",
       "      <td>5.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3599</th>\n",
       "      <td>603986.SH</td>\n",
       "      <td>25.08</td>\n",
       "      <td>22.48</td>\n",
       "      <td>4.30</td>\n",
       "      <td>2.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3600</th>\n",
       "      <td>603987.SH</td>\n",
       "      <td>11.56</td>\n",
       "      <td>10.72</td>\n",
       "      <td>1.36</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3601</th>\n",
       "      <td>603988.SH</td>\n",
       "      <td>6.99</td>\n",
       "      <td>5.32</td>\n",
       "      <td>2.86</td>\n",
       "      <td>1.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3602</th>\n",
       "      <td>603989.SH</td>\n",
       "      <td>17.88</td>\n",
       "      <td>15.52</td>\n",
       "      <td>3.61</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3603</th>\n",
       "      <td>603990.SH</td>\n",
       "      <td>18.82</td>\n",
       "      <td>13.37</td>\n",
       "      <td>7.16</td>\n",
       "      <td>1.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3604</th>\n",
       "      <td>603991.SH</td>\n",
       "      <td>15.89</td>\n",
       "      <td>11.72</td>\n",
       "      <td>6.48</td>\n",
       "      <td>3.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3605</th>\n",
       "      <td>603993.SH</td>\n",
       "      <td>9.04</td>\n",
       "      <td>8.95</td>\n",
       "      <td>3.43</td>\n",
       "      <td>2.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3606</th>\n",
       "      <td>603996.SH</td>\n",
       "      <td>7.56</td>\n",
       "      <td>4.41</td>\n",
       "      <td>6.77</td>\n",
       "      <td>6.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3607</th>\n",
       "      <td>603997.SH</td>\n",
       "      <td>19.31</td>\n",
       "      <td>17.43</td>\n",
       "      <td>4.16</td>\n",
       "      <td>0.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3608</th>\n",
       "      <td>603998.SH</td>\n",
       "      <td>9.14</td>\n",
       "      <td>7.03</td>\n",
       "      <td>2.81</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3609</th>\n",
       "      <td>603999.SH</td>\n",
       "      <td>7.08</td>\n",
       "      <td>4.08</td>\n",
       "      <td>4.43</td>\n",
       "      <td>1.14</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3610 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        ts_code  roe_5  roe_3  roe_5_std  roe_3_std\n",
       "0     000001.SZ  13.07  11.37       2.21       0.75\n",
       "1     000002.SZ  20.84  21.96       1.87       1.63\n",
       "2     000004.SZ   7.02   9.57      18.02      22.87\n",
       "3     000005.SZ   4.26   6.90       6.07       4.10\n",
       "4     000006.SZ  13.76  15.56       2.42       0.73\n",
       "5     000007.SZ  -9.45 -14.17      30.73      38.63\n",
       "6     000008.SZ   8.27   9.77       4.54       3.78\n",
       "7     000009.SZ   8.21   4.07       6.04       0.99\n",
       "8     000010.SZ -32.89 -51.38      38.40      39.56\n",
       "9     000011.SZ  17.42  19.35       5.58       3.13\n",
       "10    000012.SZ   8.77   8.49       2.08       2.36\n",
       "11    000014.SZ   8.03   7.65       5.77       7.39\n",
       "12    000016.SZ  13.25  33.76      42.66      41.77\n",
       "13    000017.SZ  14.00   6.50      21.46      12.70\n",
       "14    000018.SZ  -8.03 -30.85      69.04      79.34\n",
       "15    000019.SZ   2.82   5.47       7.03       7.78\n",
       "16    000020.SZ   0.71   1.02       1.70       0.58\n",
       "17    000021.SZ   5.94   7.52       2.72       2.46\n",
       "18    000023.SZ   5.69   5.48       1.82       2.13\n",
       "19    000025.SZ   6.48   6.30       2.02       2.35\n",
       "20    000026.SZ   6.64   5.94       1.51       1.05\n",
       "21    000027.SZ   6.76   4.25       3.38       1.40\n",
       "22    000028.SZ  14.79  13.48       2.80       2.54\n",
       "23    000029.SZ  12.77  11.88       3.27       3.94\n",
       "24    000030.SZ  14.03  14.50       1.54       0.61\n",
       "25    000031.SZ  13.79  15.47       3.07       2.88\n",
       "26    000032.SZ   4.19   4.56       2.01       2.34\n",
       "27    000034.SZ  24.84  22.28      11.87       5.95\n",
       "28    000035.SZ  12.21   8.83       5.05       1.60\n",
       "29    000036.SZ  22.13  35.09      18.30      11.74\n",
       "...         ...    ...    ...        ...        ...\n",
       "3580  603939.SH  15.08  10.66       6.02       0.61\n",
       "3581  603955.SH   9.78   9.18       1.32       0.77\n",
       "3582  603956.SH  24.69  17.91       8.75       3.47\n",
       "3583  603958.SH   9.06   1.55      10.31       6.00\n",
       "3584  603959.SH  15.98  14.10       2.75       1.70\n",
       "3585  603960.SH  16.01  15.08       1.46       1.07\n",
       "3586  603963.SH  21.03  14.30      12.24      10.29\n",
       "3587  603966.SH  11.14   9.60       2.41       1.55\n",
       "3588  603967.SH  26.35  26.60       4.29       2.82\n",
       "3589  603968.SH  14.49  13.14       2.90       0.93\n",
       "3590  603969.SH  11.08   8.55       3.92       0.87\n",
       "3591  603970.SH  24.30  18.41       8.16       4.88\n",
       "3592  603976.SH  12.81  11.39       2.72       2.42\n",
       "3593  603977.SH  12.83   8.36       6.19       3.34\n",
       "3594  603978.SH  16.64  13.99       6.08       5.88\n",
       "3595  603979.SH   8.45   5.87       4.39       1.12\n",
       "3596  603980.SH  34.62  16.19      26.37       2.36\n",
       "3597  603982.SH  11.93  11.57       1.46       1.27\n",
       "3598  603985.SH  15.77  16.06       4.50       5.47\n",
       "3599  603986.SH  25.08  22.48       4.30       2.91\n",
       "3600  603987.SH  11.56  10.72       1.36       0.52\n",
       "3601  603988.SH   6.99   5.32       2.86       1.43\n",
       "3602  603989.SH  17.88  15.52       3.61       0.45\n",
       "3603  603990.SH  18.82  13.37       7.16       1.53\n",
       "3604  603991.SH  15.89  11.72       6.48       3.54\n",
       "3605  603993.SH   9.04   8.95       3.43       2.57\n",
       "3606  603996.SH   7.56   4.41       6.77       6.98\n",
       "3607  603997.SH  19.31  17.43       4.16       0.48\n",
       "3608  603998.SH   9.14   7.03       2.81       0.60\n",
       "3609  603999.SH   7.08   4.08       4.43       1.14\n",
       "\n",
       "[3610 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "'''\n",
    "将所有stock的指标集中到一个df\n",
    "并计算5年，3年的平均roe\n",
    "'''\n",
    "df_indicator = pd.DataFrame()\n",
    "list_roe_result = []\n",
    "year_5_mean = [20181231,20171231,20161231,20151231,20141231]\n",
    "year_3_mean = [20181231,20171231,20161231]\n",
    "# 计算了5年，3年roe平均以及std\n",
    "for stock_indicator in all_csv_file:\n",
    "    file_path = ts_indicator + stock_indicator\n",
    "    df_tmp_indicator = pd.read_csv(file_path)\n",
    "    #print(df_tmp_indicator)\n",
    "    df_indicator = df_indicator.append(df_tmp_indicator,ignore_index=True)\n",
    "    list_roe_5 = []\n",
    "    list_roe_3 = []\n",
    "    df_tmp_indicator = pd.read_csv(file_path, index_col=[\"end_date\"])\n",
    "    for year in year_5_mean:\n",
    "        if year in df_tmp_indicator.index:\n",
    "            list_roe_5.append(df_tmp_indicator.loc[year,[\"roe\"]][\"roe\"])\n",
    "    for year in year_3_mean:\n",
    "        if year in df_tmp_indicator.index:\n",
    "            list_roe_3.append(df_tmp_indicator.loc[year,[\"roe\"]][\"roe\"])\n",
    "    #print([stock_indicator[0:9], list_roe_5, list_roe_3])\n",
    "    tmp_5_mean = round(sum(list_roe_5)/len(list_roe_5),2)\n",
    "    tmp_3_mean = round(sum(list_roe_3)/len(list_roe_3),2)\n",
    "    tmp_5_std = round(np.std(list_roe_5),2)\n",
    "    tmp_3_std = round(np.std(list_roe_3),2)\n",
    "    list_roe_result.append([stock_indicator[0:9], tmp_5_mean, tmp_3_mean, tmp_5_std, tmp_3_std])\n",
    "roe_columns_name = [\"ts_code\", \"roe_5\", \"roe_3\", \"roe_5_std\", \"roe_3_std\"]\n",
    "df_roe_mean = pd.DataFrame(data=list_roe_result, columns=roe_columns_name)\n",
    "        \n",
    "df_roe_mean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_roe_mean = df_roe_mean.set_index([\"ts_code\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 指标筛选，将所有需要筛选的指标放到该list\n",
    "filter_columns_name = [\"roe\", \"roe_dt\",\"roe_waa\", \"roe_yearly\", \"debt_to_assets\", \"ocfps\", \"ts_code\",\"end_date\"]\n",
    "df_analyse = df_indicator[filter_columns_name]\n",
    "#df_analyse"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = df_analyse.set_index([\"ts_code\"])\n",
    "#"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = df_analyse[df_analyse[\"end_date\"]==20181231]\n",
    "#df_analyse = df_analyse.sort_values(by=[\"roe\"],ascending=False)\n",
    "#df_analyse = df_analyse[df_analyse[\"roe\"]>=15]\n",
    "df_analyse = pd.merge(df_analyse,df_stock_name,left_index=True,right_index=True)\n",
    "df_analyse = pd.merge(df_analyse,df_roe_mean,left_index=True,right_index=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 再增加一个审计师为四大的标准\n",
    "audit_file_path = \"C:\\\\quanttime\\\\data\\\\finance\\\\audit\\\\\"\n",
    "all_audit_file = os.listdir(audit_file_path)\n",
    "df_audit = pd.DataFrame()\n",
    "columns_name = [\"ts_code\", \"end_date\", \"audit_result\", \"audit_agency\"]\n",
    "audit_top = [u'普华永道中天会计师事务所', u'安永华明会计师事务所', u'毕马威华振会计师事务所', u'德勤华永会计师事务所']\n",
    "for audit in all_audit_file:\n",
    "    df_data = pd.read_csv(audit_file_path+audit, encoding=\"gbk\",usecols=columns_name)\n",
    "    df_audit = df_audit.append(df_data.iloc[0])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>audit_agency</th>\n",
       "      <th>audit_result</th>\n",
       "      <th>end_date</th>\n",
       "      <th>ts_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000001.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000039.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000099.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000333.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000418.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000539.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000550.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000608.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000652.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000708.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000951.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002024.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002045.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002352.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002463.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002602.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002701.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002938.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300149.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300308.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300658.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300682.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300736.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300741.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300760.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600000.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600006.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600007.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600012.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600023.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600028.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600030.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>带强调事项段的无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600221.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600258.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600297.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600315.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600379.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600528.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600545.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>带强调事项段的无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600555.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600600.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600619.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600649.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600660.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600663.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600688.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>带强调事项段的无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600751.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600779.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600835.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600874.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600901.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601018.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601021.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601066.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601138.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601155.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601179.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601288.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601318.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601328.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601333.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601390.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601588.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601595.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601601.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601607.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601608.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601668.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601727.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601939.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601966.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601996.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601998.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603157.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603608.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603883.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000027.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000028.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000063.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000338.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000415.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000423.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000625.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000736.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000776.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000895.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000933.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000999.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>001896.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002083.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002085.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002088.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002142.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002202.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002269.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002314.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002333.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002558.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002594.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300037.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300357.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300493.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300511.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300676.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600019.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600062.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600115.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600138.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600171.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600196.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600320.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600362.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600415.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600511.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600548.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600584.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600588.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600657.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600808.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600841.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600926.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600983.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600995.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601005.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601009.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601168.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601169.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601200.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601211.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601326.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601336.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601555.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601600.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601628.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601788.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601800.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601818.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601828.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601838.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601880.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601899.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601988.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601992.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601997.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603214.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603421.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603556.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603650.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603659.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000002.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000166.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000639.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000698.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000725.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002422.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002500.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002936.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600011.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600016.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600029.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600050.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600299.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600585.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600699.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600713.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600919.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601006.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601116.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601139.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601229.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601330.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601398.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601688.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601857.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601869.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601888.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603288.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603886.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000042.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000553.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000750.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000869.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000935.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>001872.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>001979.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002415.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002467.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002713.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002906.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300017.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600015.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600036.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600104.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600162.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600215.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600230.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600246.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600309.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600377.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600383.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600458.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600500.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600508.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600597.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600650.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600741.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600754.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600801.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600822.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600958.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>600999.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601088.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601111.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601166.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601186.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601198.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601231.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601319.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601360.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601377.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601618.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601633.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601766.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601808.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601811.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601881.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601898.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603117.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603259.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603323.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603993.SH</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   audit_agency  audit_result    end_date    ts_code\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000001.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000039.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000099.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000333.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000418.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000539.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000550.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000608.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000652.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000708.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  000951.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002024.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002045.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002352.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002463.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002602.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002701.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  002938.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300149.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300308.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300658.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300682.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300736.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300741.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  300760.SZ\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600000.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600006.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600007.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600012.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600023.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600028.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600030.SH\n",
       "0  普华永道中天会计师事务所  带强调事项段的无保留意见  20181231.0  600221.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600258.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600297.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600315.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600379.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600528.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600545.SH\n",
       "0  普华永道中天会计师事务所  带强调事项段的无保留意见  20181231.0  600555.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600600.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600619.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600649.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600660.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600663.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600688.SH\n",
       "0  普华永道中天会计师事务所  带强调事项段的无保留意见  20181231.0  600751.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600779.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600835.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600874.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  600901.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601018.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601021.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601066.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601138.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601155.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601179.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601288.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601318.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601328.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601333.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601390.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601588.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601595.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601601.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601607.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601608.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601668.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601727.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601939.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601966.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601996.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  601998.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  603157.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  603608.SH\n",
       "0  普华永道中天会计师事务所       标准无保留意见  20181231.0  603883.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000027.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000028.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000063.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000338.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000415.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000423.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000625.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000736.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000776.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000895.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000933.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  000999.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  001896.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002083.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002085.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002088.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002142.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002202.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002269.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002314.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002333.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002558.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  002594.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  300037.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  300357.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  300493.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  300511.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  300676.SZ\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600019.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600062.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600115.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600138.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600171.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600196.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600320.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600362.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600415.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600511.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600548.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600584.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600588.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600657.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600808.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600841.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600926.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600983.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  600995.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601005.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601009.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601168.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601169.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601200.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601211.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601326.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601336.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601555.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601600.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601628.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601788.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601800.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601818.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601828.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601838.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601880.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601899.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601988.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601992.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  601997.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  603214.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  603421.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  603556.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  603650.SH\n",
       "0    安永华明会计师事务所       标准无保留意见  20181231.0  603659.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  000002.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  000166.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  000639.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  000698.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  000725.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  002422.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  002500.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  002936.SZ\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600011.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600016.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600029.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600050.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600299.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600585.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600699.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600713.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  600919.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601006.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601116.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601139.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601229.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601330.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601398.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601688.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601857.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601869.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  601888.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  603288.SH\n",
       "0   毕马威华振会计师事务所       标准无保留意见  20181231.0  603886.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  000042.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  000553.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  000750.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  000869.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  000935.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  001872.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  001979.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  002415.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  002467.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  002713.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  002906.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  300017.SZ\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600015.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600036.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600104.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600162.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600215.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600230.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600246.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600309.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600377.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600383.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600458.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600500.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600508.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600597.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600650.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600741.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600754.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600801.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600822.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600958.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  600999.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601088.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601111.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601166.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601186.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601198.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601231.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601319.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601360.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601377.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601618.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601633.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601766.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601808.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601811.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601881.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  601898.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  603117.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  603259.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  603323.SH\n",
       "0    德勤华永会计师事务所       标准无保留意见  20181231.0  603993.SH"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 筛选出四大\n",
    "df_audit_phyd = df_audit[df_audit[\"audit_agency\"]==u'普华永道中天会计师事务所']\n",
    "df_audit_ay = df_audit[df_audit[\"audit_agency\"]==u'安永华明会计师事务所']\n",
    "df_audit_pwc = df_audit[df_audit[\"audit_agency\"]==u'毕马威华振会计师事务所']\n",
    "df_audit_dq = df_audit[df_audit[\"audit_agency\"]==u'德勤华永会计师事务所']\n",
    "df_audit_top = pd.concat([df_audit_phyd,df_audit_ay,df_audit_pwc,df_audit_dq])\n",
    "df_audit_top"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = df_analyse[df_analyse[\"debt_to_assets\"]<=40.5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = df_analyse[df_analyse[\"ocfps\"]>0]\n",
    "df_analyse = df_analyse[df_analyse[\"roe_5_std\"]<=4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = df_analyse[df_analyse[\"roe_5\"]>=15]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse = pd.merge(df_analyse,df_audit_top,left_index=True, right_on=\"ts_code\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>roe</th>\n",
       "      <th>roe_dt</th>\n",
       "      <th>roe_waa</th>\n",
       "      <th>roe_yearly</th>\n",
       "      <th>debt_to_assets</th>\n",
       "      <th>ocfps</th>\n",
       "      <th>end_date_x</th>\n",
       "      <th>name</th>\n",
       "      <th>roe_5</th>\n",
       "      <th>roe_3</th>\n",
       "      <th>roe_5_std</th>\n",
       "      <th>roe_3_std</th>\n",
       "      <th>audit_agency</th>\n",
       "      <th>audit_result</th>\n",
       "      <th>end_date_y</th>\n",
       "      <th>ts_code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>33.4162</td>\n",
       "      <td>32.3282</td>\n",
       "      <td>33.99</td>\n",
       "      <td>33.4162</td>\n",
       "      <td>40.1992</td>\n",
       "      <td>0.9877</td>\n",
       "      <td>20181231</td>\n",
       "      <td>海康威视</td>\n",
       "      <td>34.45</td>\n",
       "      <td>33.98</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.43</td>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002415.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>34.0622</td>\n",
       "      <td>32.1837</td>\n",
       "      <td>32.66</td>\n",
       "      <td>34.0622</td>\n",
       "      <td>31.0565</td>\n",
       "      <td>2.2205</td>\n",
       "      <td>20181231</td>\n",
       "      <td>海天味业</td>\n",
       "      <td>32.88</td>\n",
       "      <td>32.27</td>\n",
       "      <td>2.30</td>\n",
       "      <td>1.54</td>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603288.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35.6237</td>\n",
       "      <td>33.6953</td>\n",
       "      <td>34.06</td>\n",
       "      <td>35.6237</td>\n",
       "      <td>37.3578</td>\n",
       "      <td>1.5744</td>\n",
       "      <td>20181231</td>\n",
       "      <td>双汇发展</td>\n",
       "      <td>29.49</td>\n",
       "      <td>31.34</td>\n",
       "      <td>3.31</td>\n",
       "      <td>3.09</td>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000895.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26.3031</td>\n",
       "      <td>25.3973</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.3031</td>\n",
       "      <td>5.9053</td>\n",
       "      <td>0.7098</td>\n",
       "      <td>20181231</td>\n",
       "      <td>我武生物</td>\n",
       "      <td>24.04</td>\n",
       "      <td>24.24</td>\n",
       "      <td>2.36</td>\n",
       "      <td>2.41</td>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300357.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19.0555</td>\n",
       "      <td>16.4139</td>\n",
       "      <td>16.42</td>\n",
       "      <td>19.0555</td>\n",
       "      <td>33.0484</td>\n",
       "      <td>1.0430</td>\n",
       "      <td>20181231</td>\n",
       "      <td>爱婴室</td>\n",
       "      <td>23.96</td>\n",
       "      <td>24.39</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.81</td>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603214.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>19.7184</td>\n",
       "      <td>18.1129</td>\n",
       "      <td>19.72</td>\n",
       "      <td>19.7184</td>\n",
       "      <td>18.3198</td>\n",
       "      <td>1.5428</td>\n",
       "      <td>20181231</td>\n",
       "      <td>东阿阿胶</td>\n",
       "      <td>23.28</td>\n",
       "      <td>22.09</td>\n",
       "      <td>2.02</td>\n",
       "      <td>1.81</td>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000423.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>16.1130</td>\n",
       "      <td>14.5903</td>\n",
       "      <td>14.57</td>\n",
       "      <td>16.1130</td>\n",
       "      <td>5.4608</td>\n",
       "      <td>2.0582</td>\n",
       "      <td>20181231</td>\n",
       "      <td>华宝股份</td>\n",
       "      <td>21.72</td>\n",
       "      <td>21.14</td>\n",
       "      <td>2.99</td>\n",
       "      <td>3.62</td>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>300741.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>22.1830</td>\n",
       "      <td>21.7692</td>\n",
       "      <td>22.06</td>\n",
       "      <td>22.1830</td>\n",
       "      <td>34.9961</td>\n",
       "      <td>0.7459</td>\n",
       "      <td>20181231</td>\n",
       "      <td>长飞光纤</td>\n",
       "      <td>21.61</td>\n",
       "      <td>22.58</td>\n",
       "      <td>3.30</td>\n",
       "      <td>3.43</td>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601869.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18.8139</td>\n",
       "      <td>12.9717</td>\n",
       "      <td>23.98</td>\n",
       "      <td>18.8139</td>\n",
       "      <td>19.8612</td>\n",
       "      <td>1.4084</td>\n",
       "      <td>20181231</td>\n",
       "      <td>药明康德</td>\n",
       "      <td>18.13</td>\n",
       "      <td>20.41</td>\n",
       "      <td>3.52</td>\n",
       "      <td>1.23</td>\n",
       "      <td>德勤华永会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>603259.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20.4487</td>\n",
       "      <td>20.7764</td>\n",
       "      <td>20.56</td>\n",
       "      <td>20.4487</td>\n",
       "      <td>30.7781</td>\n",
       "      <td>1.3942</td>\n",
       "      <td>20181231</td>\n",
       "      <td>中国国旅</td>\n",
       "      <td>16.83</td>\n",
       "      <td>18.22</td>\n",
       "      <td>2.44</td>\n",
       "      <td>2.21</td>\n",
       "      <td>毕马威华振会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>601888.SH</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>18.3703</td>\n",
       "      <td>17.2945</td>\n",
       "      <td>19.75</td>\n",
       "      <td>18.3703</td>\n",
       "      <td>34.6056</td>\n",
       "      <td>2.6865</td>\n",
       "      <td>20181231</td>\n",
       "      <td>鹏鼎控股</td>\n",
       "      <td>15.44</td>\n",
       "      <td>14.81</td>\n",
       "      <td>2.93</td>\n",
       "      <td>3.65</td>\n",
       "      <td>普华永道中天会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>002938.SZ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>13.8591</td>\n",
       "      <td>12.1364</td>\n",
       "      <td>13.86</td>\n",
       "      <td>13.8591</td>\n",
       "      <td>38.0558</td>\n",
       "      <td>1.9524</td>\n",
       "      <td>20181231</td>\n",
       "      <td>华润三九</td>\n",
       "      <td>15.25</td>\n",
       "      <td>14.26</td>\n",
       "      <td>1.33</td>\n",
       "      <td>0.40</td>\n",
       "      <td>安永华明会计师事务所</td>\n",
       "      <td>标准无保留意见</td>\n",
       "      <td>20181231.0</td>\n",
       "      <td>000999.SZ</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       roe   roe_dt  roe_waa  roe_yearly  debt_to_assets   ocfps  end_date_x  \\\n",
       "0  33.4162  32.3282    33.99     33.4162         40.1992  0.9877    20181231   \n",
       "0  34.0622  32.1837    32.66     34.0622         31.0565  2.2205    20181231   \n",
       "0  35.6237  33.6953    34.06     35.6237         37.3578  1.5744    20181231   \n",
       "0  26.3031  25.3973    26.63     26.3031          5.9053  0.7098    20181231   \n",
       "0  19.0555  16.4139    16.42     19.0555         33.0484  1.0430    20181231   \n",
       "0  19.7184  18.1129    19.72     19.7184         18.3198  1.5428    20181231   \n",
       "0  16.1130  14.5903    14.57     16.1130          5.4608  2.0582    20181231   \n",
       "0  22.1830  21.7692    22.06     22.1830         34.9961  0.7459    20181231   \n",
       "0  18.8139  12.9717    23.98     18.8139         19.8612  1.4084    20181231   \n",
       "0  20.4487  20.7764    20.56     20.4487         30.7781  1.3942    20181231   \n",
       "0  18.3703  17.2945    19.75     18.3703         34.6056  2.6865    20181231   \n",
       "0  13.8591  12.1364    13.86     13.8591         38.0558  1.9524    20181231   \n",
       "\n",
       "   name  roe_5  roe_3  roe_5_std  roe_3_std  audit_agency audit_result  \\\n",
       "0  海康威视  34.45  33.98       0.80       0.43    德勤华永会计师事务所      标准无保留意见   \n",
       "0  海天味业  32.88  32.27       2.30       1.54   毕马威华振会计师事务所      标准无保留意见   \n",
       "0  双汇发展  29.49  31.34       3.31       3.09    安永华明会计师事务所      标准无保留意见   \n",
       "0  我武生物  24.04  24.24       2.36       2.41    安永华明会计师事务所      标准无保留意见   \n",
       "0   爱婴室  23.96  24.39       3.16       3.81    安永华明会计师事务所      标准无保留意见   \n",
       "0  东阿阿胶  23.28  22.09       2.02       1.81    安永华明会计师事务所      标准无保留意见   \n",
       "0  华宝股份  21.72  21.14       2.99       3.62  普华永道中天会计师事务所      标准无保留意见   \n",
       "0  长飞光纤  21.61  22.58       3.30       3.43   毕马威华振会计师事务所      标准无保留意见   \n",
       "0  药明康德  18.13  20.41       3.52       1.23    德勤华永会计师事务所      标准无保留意见   \n",
       "0  中国国旅  16.83  18.22       2.44       2.21   毕马威华振会计师事务所      标准无保留意见   \n",
       "0  鹏鼎控股  15.44  14.81       2.93       3.65  普华永道中天会计师事务所      标准无保留意见   \n",
       "0  华润三九  15.25  14.26       1.33       0.40    安永华明会计师事务所      标准无保留意见   \n",
       "\n",
       "   end_date_y    ts_code  \n",
       "0  20181231.0  002415.SZ  \n",
       "0  20181231.0  603288.SH  \n",
       "0  20181231.0  000895.SZ  \n",
       "0  20181231.0  300357.SZ  \n",
       "0  20181231.0  603214.SH  \n",
       "0  20181231.0  000423.SZ  \n",
       "0  20181231.0  300741.SZ  \n",
       "0  20181231.0  601869.SH  \n",
       "0  20181231.0  603259.SH  \n",
       "0  20181231.0  601888.SH  \n",
       "0  20181231.0  002938.SZ  \n",
       "0  20181231.0  000999.SZ  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_analyse.sort_values(by=[\"roe_5\"],ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_analyse.sort_values(by=[\"roe_5\"],ascending=False).to_csv(r\"c:\\quanttime\\data\\tmp\\indicator_roe.csv\",encoding=\"gbk\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "roe                34.4643\n",
       "roe_dt             34.8382\n",
       "roe_waa              34.46\n",
       "roe_yearly         34.4643\n",
       "debt_to_assets     26.5493\n",
       "ocfps              32.9448\n",
       "end_date          20181231\n",
       "name                  贵州茅台\n",
       "roe_5                30.05\n",
       "roe_3                30.62\n",
       "roe_5_std              3.9\n",
       "roe_3_std             4.41\n",
       "Name: 600519.SH, dtype: object"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_analyse.loc[\"600519.SH\"]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
